Carson Penticuff
Carson Penticuff
Reactions
-
Re: How to Add Zeros to a # to Equal a Total of 4 Digits
This should give you result you want visually. With this, you lose the "number" formatting and the Store No is treated as text. =IF(LEN([Store]@row) = 3, "0" + [Store]@row, [Store…1 · -
Re: date needed before being able to keep entering data
I don't believe there is a way to "prevent" them from entering data until the date is filled in. One somewhat "hackey" workaround would be to set conditional formatting for the ce…1 · -
Re: Average formula with an IF statement
There sure is! =IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 1, "Almost Medium", IF(AVG(Duration@row, [Exis…1 · -
Re: Is it possible to figure out which sheet an automated message came from?
There should be a workflow id# at the bottom of the email. If you contact customer support, they may be able to provide the sheet name based on that ID.1 · -
Re: How to run multiple IF functions independently of each other in the same cell?
This will concatenate the results of multiple IF statements. =IF(PPE@row <> "", "PPE") + IF(PPE@row <> "", " ","") + IF([Work Environment…1 ·
